SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 54878: Slow performance occurs when you open a SAS® Customer Due Diligence case in the SAS® Anti-Money Laundering investigation user interface

DetailsHotfixAboutRate It

Slow performance occurs when you open a SAS Customer Due Diligence case in the Case Details window that is available from the SAS Anti-Money Laundering investigation user interface (UI).

Performance has been improved already by optimization of the SQL queries that are called in the SAS® Stored Processes. You can also improve performance in the following ways:

  • Create two new indexes for the Knowledge Center table FSK_CDD_SCORING_EVENT by submitting the following statements:
    create index FCFKC.XIF2FSK_CDD_SCORING_EVENT on FCFKC.FSK_CDD_SCORING_EVENT (investigation_rk ASC); create index FCFKC.XIF3FSK_CDD_SCORING_EVENT on FCFKC.FSK_CDD_SCORING_EVENT (primary_entity_number ASC);
  • Remove unnecessary stored-process calls within the UI definition files.
  • Use the lazy-load process to load data into the UI.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money LaunderingMicrosoft® Windows® for x646.1_M16.1_M19.4 TS1M39.4 TS1M3
64-bit Enabled AIX6.1_M16.1_M19.4 TS1M39.4 TS1M3
64-bit Enabled Solaris6.1_M16.1_M19.4 TS1M39.4 TS1M3
HP-UX IPF6.1_M16.1_M19.4 TS1M39.4 TS1M3
Linux for x646.1_M16.1_M19.4 TS1M39.4 TS1M3
Solaris for x646.1_M16.1_M19.4 TS1M39.4 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.